package com.gis.entity;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import io.swagger.v3.oas.annotations.media.Schema;
import lombok.Data;

@Data
@TableName(value = "ocean_bouy_data")
public class OceanBouyData {
    /*
     * springboot MyBatis无法查询出属性名和数据库字段名不完全相同的数据
     * 需要@TableField指定属性
     */
    
    @TableId(type = IdType.AUTO)
    private Integer id;

    @Schema(description = "站点ID")
    @TableField("station_id")
    private Integer stationId;
    
    @Schema(description = "盐度")
    private Float psu;
    @Schema(description = "PH")
    private Float ph;
    @Schema(description = "溶解氧")
    private Float dissolvedOxygen;
    @Schema(description = "需氧量")
    private Float cod;
    @Schema(description = "硝酸盐")
    private Float no3;
    @Schema(description = "亚硝酸盐")
    private Float no2;
    @Schema(description = "氨氮")
    private Float nh4;
    @Schema(description = "磷酸盐")
    private Float po4;
    @Schema(description = "石油类")
    @TableField("petroleum_class")
    private Float petroleumClass;
    @Schema(description = "浊度")
    private Float ftu;
    @Schema(description = "叶绿素a")
    private Float chla;
    @Schema(description = "蓝绿藻")
    private Float bga;

    private Integer year;
    private Integer month;
}
